﻿CREATE proc capnhatquyentrenmenu  
@ID int,  
@CapNhat int,  
@Xem int,  
@Xoa int  
as  
update QuanTri_PhanNhomMenu set  
Quyen_CapNhat=@CapNhat,Quyen_Xem=@Xem,Quyen_Xoa=@Xoa  
Where ID=@ID  
update QuanTri_EditUserRoleInGroup set Quyen_CapNhat=@CapNhat,Quyen_Xem=@Xem,Quyen_Xoa=@Xoa  
Where IDPhanNhomMenu=@ID
--select * from QuanTri_EditUserRoleInGroup
select ErrCode=1